﻿CREATE PROCEDURE [dbo].[AddMessage]
	@MessageId uniqueidentifier,
	@Subject nvarchar(150),
    @Content nvarchar(max),
	@SentOn datetime,
	@Priority int,
    @From uniqueidentifier,
    @To uniqueidentifier,
    @IsDeleted bit,
	@CreatedOn datetime

AS

	INSERT INTO [Message]

	(MessageId, [Subject], Content, SentOn, [Priority], [From], [To], IsDeleted, CreatedOn)

	VALUES 

	(@MessageId, @Subject, @Content, @SentOn, @Priority, @From, @To, @IsDeleted, @CreatedOn)

RETURN 0